Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
IssuingRetailStoreID (FK)(PK) | A unique store number reference to identify the RETAIL STORE that issued the GIFT CERTIFICATE. | ID_STR_ISSG | Identity | integer | RetailStore(PA_STR_RTL) |
GiftCertificateSerialNumber (PK) | The serial number that uniquely identifies a GIFT CERTIFICATE. | ID_NMB_SRZ_GF_CF | IdentityUUID | char(32) | |
GiftCertificateTypeCode (FK) | | TY_GF_CF | Code2 | char(2) | GiftCertificateClass(CO_CLS_GF_CF) |
IssueTypeCode | A code to denote how GIFT CERTIFICATEs are issued by the RETAIL STORE, e.g. embossed or printed at the point of sale. | TY_ISS_GF_CF | Code2 | char(2) | |
IssueDateTimestamp | The time and date when the gift certificate was issued by the retail enterprise. | TS_ISS_GF_CF | AuditDateTime | datetime | |
ActivatedDateTimestamp | The time and date when the gift certificate was activated by the retail enterprise | TS_ACTV | AuditDateTime | datetime | |
ExpirationDate | The expiration date when the GIFT CERTIFICATE can no longer be tendered. | DC_EP_GF_CF | ExpirationDate | date | |
FaceValueAmount | The monetary value printed or embossed on the GIFT CERTIFICATE. | MO_VL_FC_GF_CF | Money | decimal(16,5) | |
UnspentBalanceAmount | The monetary value of the unspent amount outstanding on a specific GIFT CERTIFICATE. | MO_BLNC_UNSP | Money | decimal(16,5) | |